<?php

$data = array('msg' => null, 'type' => 'software', 'table' => 'software');

$data['search_fields'] = array(
  'product',
  'version',
  'serialns',
  'comment_software'
);

$data['joins'] = array(
  'vendors',
  'products',
  'versions'
);

$data['join_fields'] = array(
  '`vendor_id`=`vendors`.`id`',
  '`product_id`=`products`.`id`',
  '`version_id`=`versions`.`id`'
);

$data['list_fields'] = array(
  'version_id'
);

$data['null_fields'] = array(
  'serialns'
);

$data['alias'] = array(
  '*, `software`.id',
  'SUBSTRING(comment_software, 1, 30) AS comm_s'
);

$data['order'] = 'product, version, serialns';

?>
